﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="APIList.aspx.cs" Inherits="Web.APIList" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataKeyNames="ID" DataSourceID="SqlDataSourceList">
            <Columns>
                <asp:BoundField DataField="Note" HeaderText="Note" SortExpression="Note" />
                <asp:BoundField DataField="ResultSample" HeaderText="ResultSample" 
                    SortExpression="ResultSample" />
                <asp:BoundField DataField="Addition" HeaderText="Addition" 
                    SortExpression="Addition" />
                <asp:BoundField DataField="ModifyDate" HeaderText="ModifyDate" 
                    SortExpression="ModifyDate" />
                <asp:CheckBoxField DataField="NeedLogin" HeaderText="NeedLogin" 
                    SortExpression="NeedLogin" />
                <asp:BoundField DataField="RequestMethod" HeaderText="RequestMethod" 
                    SortExpression="RequestMethod" />
                <asp:BoundField DataField="ResponseFormatID" HeaderText="ResponseFormatID" 
                    SortExpression="ResponseFormatID" />
                <asp:BoundField DataField="Description" HeaderText="Description" 
                    SortExpression="Description" />
                <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSourceList" runat="server" 
            ConnectionString="<%$ ConnectionStrings:OnlineAPIConnectionString %>" 
            
            SelectCommand="SELECT [ID], [Note], [ResultSample], [Addition], [ModifyDate], [NeedLogin], [RequestMethod], [ResponseFormatID], [Description], [Name] FROM [API] WHERE ([GroupID] = @GroupID)">
            <SelectParameters>
                <asp:QueryStringParameter DefaultValue="0" Name="GroupID" 
                    QueryStringField="GroupID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
    
    </div>
    </form>
</body>
</html>
